﻿CREATE TABLE [dbo].[UDS_CM_ClientContact] (
    [ID]               int            NOT NULL identity(1, 1),
    [ClientID]         int            NOT NULL,
    [MarketmanID]      int            NULL,
    [UpdateTime]       datetime       NULL,
    [ContactTimes]     int            NULL,
    [CurStatus]        nvarchar(100)  COLLATE Chinese_PRC_CI_AS NULL,
    [ContactAim]       nvarchar(500)  COLLATE Chinese_PRC_CI_AS NULL,
    [SellMoney]        int            NULL,
    [BargainPrognosis] nvarchar(50)   COLLATE Chinese_PRC_CI_AS NULL,
    [ContactType]      nvarchar(50)   COLLATE Chinese_PRC_CI_AS NULL,
    [Fee]              int            NULL,
    [ContactContent]   nvarchar(1000) COLLATE Chinese_PRC_CI_AS NULL,
    [NextContactAim]   nvarchar(1000) COLLATE Chinese_PRC_CI_AS NULL,
    [NextContactTime]  datetime       NULL,
    [FeeUsed]          nvarchar(100)  COLLATE Chinese_PRC_CI_AS NULL,
    [ContactTime]      datetime       NULL,

    CONSTRAINT [PK_UDS_CM_ClientContact] PRIMARY KEY CLUSTERED ([ID] asc),
    CONSTRAINT [FK_UDS_CM_ClientContact_UDS_Staff] FOREIGN KEY ([MarketmanID]) REFERENCES [dbo].[UDS_Staff] ([Staff_ID])
);
GO
